﻿--check
create proc [dbo].[proc_SitePersonnel_Check]
(
	@sid int,
	@departmentid int,
	@username nvarchar(50)
)
as
	select * from SitePersonnel where sid=@sid and departmentid=@departmentid and username=@username
